Exporting Data to Excel

There are two options in Report Output for exporting data:

  • Export Data (DBF File)
  • Export Data (Tab Separated)
Note - To see free text comments of any entry in Vision 3 on an extracted file, you must select Export Data (Tab Separated).

To export data to Excel:

  1. From Report Output, select one of the Export Data options:

    See Creating a Search for help with creating a search if required.
  2. Select Run to generate the search and the Browse for Folder screen displays:

  3. The Save to screen displays, select the directory to save the extract to.
  4. Select OK to proceed.
  5. If you have previously exported a search to this destination, a warning displays 'XXXXXXX database exists, it will be overwritten, continue', select Yes to proceed.

    Each export creates a patient file:

    • Tab Separated - patient.txt
    • DBF - patient.dbf, patient.cdx and patient.fpt

    Additional files are created for each entity, for example, a medication search generates file(s) with the name therapy.XXX.

See Importing a TXT File into Excel and Creating a Pivot Table in Excel for further details.

Video Tutorials

Exporting to Excel (1.58)